<HTML>
<HEAD>
<TITLE>program</TITLE>
<META content="text/html; charset=Turkish (Windows)" http-equiv=Content-Type>
<LINK HREF="../HTMLReport.css" type=text/css rel=STYLESHEET>
</HEAD>
<BODY>
<DIV ID="nsbanner">
  <DIV ID="bannerrow1">
    <TABLE CLASS="bannerparthead" CELLSPACING=0>
      <TR ID="hdr" VALIGN="middle">
        <TD CLASS="runninghead"><pre>localhost/isproje - isproje on localhost</pre></TD>
                <TD ALIGN="left" WIDTH="54px" NOWRAP>
          <A HREF="personnelpayment.html"><IMG ALT="Previous topic" SRC="../Images/GoPrev.bmp" BORDER="0"></A>
          <A HREF="../Index.html"><IMG ALT="Chapter index" SRC="../Images/GoIndex.bmp" BORDER="0"></A>
          <A HREF="room.html"><IMG ALT="Next topic" SRC="../Images/GoNext.bmp" BORDER="0"></A>
        </TD>
      </TR>
    </TABLE>
  </DIV>
  <DIV ID="TitleRow">
    <P CLASS="dtH1">program</P>
  </DIV>
</DIV>
<P CLASS="Base">&nbsp;</P>
<P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Descriptions</P>
<P CLASS="Base">InnoDB free: 54272 kB</P>
<P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Fields</P>
<TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%>
<TH WIDTH="1%"><P CLASS="Base2"><B>PK</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Name</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Data type</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Size</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Precision</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Values</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Default</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Auto Increment</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Binary</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Not null</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Unsigned</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Zero Fill</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Unique</B></P>
<TR>
<TD ALIGN="middle"><P CLASS="Base2"><IMG SRC="../Images/Yes.bmp" BORDER="0"></P></TD>
<TD><P CLASS="Base2">programCode</P></TD>
<TD><P CLASS="Base2">INTEGER</P></TD>
<TD><P CLASS="Base2">4</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2"><IMG SRC="../Images/Yes.bmp" BORDER="0"></P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
</TR>
<TR>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">shortName</P></TD>
<TD><P CLASS="Base2">VARCHAR</P></TD>
<TD><P CLASS="Base2">6</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2"><IMG SRC="../Images/Yes.bmp" BORDER="0"></P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
</TR>
<TR>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">longName</P></TD>
<TD><P CLASS="Base2">VARCHAR</P></TD>
<TD><P CLASS="Base2">32</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2"><IMG SRC="../Images/Yes.bmp" BORDER="0"></P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
</TR>
<TR>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">thesisStatus</P></TD>
<TD><P CLASS="Base2">TINYINT</P></TD>
<TD><P CLASS="Base2">1</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
</TR>
</TABLE>

<P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Indices</P>
<TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%>
<TH WIDTH="1%"><P CLASS="Base2"><B>Name</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Fields</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Unique</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Collation</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Full Text</B></P>
<TR>
<TD><P CLASS="Base2">PRIMARY</P></TD>
<TD><P CLASS="Base2">programCode</P></TD>
<TD ALIGN="middle"><P CLASS="Base2"><IMG SRC="../Images/Yes.bmp" BORDER="0"></P></TD>
<TD><P CLASS="Base2">Ascending</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
</TR>
</TABLE>

<P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Foreign Keys</P>
<P CLASS="Base">There are no foreign keys for table program</P><P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Triggers</P>
<P CLASS="Base">There are no triggers for table program</P><P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Options</P>
<TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%>
<TH WIDTH="1%"><P CLASS="Base2"><B>TransactSafe</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>TableType</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Row Format</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Check Sum</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Delay Key Write</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Pack Keys</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Temporary</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Min Rows</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Max Rows</B></P>
<TH WIDTH="1%"><P CLASS="Base2"><B>Union</B></P>
<TR>
<TD ALIGN="middle"><P CLASS="Base2"><IMG SRC="../Images/Yes.bmp" BORDER="0"></P></TD>
<TD><P CLASS="Base2">InnoDB</P></TD>
<TD><P CLASS="Base2">Ascending</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD ALIGN="middle"><P CLASS="Base2">&nbsp;</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD><P CLASS="Base2">0</P></TD>
<TD><P CLASS="Base2">&nbsp;</P></TD>
</TR>
</TABLE>

<P CLASS="Base">&nbsp;</P>
<P CLASS="Header1">Definition</P>
<P CLASS="Base">
<blockquote><code><pre><basefont size=1 face="Courier New"><font size= +2>
<b>CREATE</b> TABLE</b> </b>`program` (
  `programCode` <b>int</b>(4) <b>NOT</b> NULL</b> default</b> </b>'0',
  `shortName` <b>varchar</b>(6) <b>NOT</b> NULL</b>,
  `longName` <b>varchar</b>(32) <b>NOT</b> NULL</b>,
  `thesisStatus` <b>tinyint</b>(1) <b>default</b> </b>'0',
  <b>PRIMARY</b> KEY</b>  </b>(`programCode`)
) <b>ENGINE</b>=<b>InnoDB</b> DEFAULT</b> CHARSET</b>=latin5;
</font></basefont></pre></code></blockquote>
</P>
<DIV CLASS="footer"><BR><HR></DIV>
    <TABLE CLASS="bannerparthead" CELLSPACING=0>
    <TR VALIGN="middle">
    <TD CLASS="runninghead"><pre>This file was generated with SQL Manager 2005 for MySQL (<A HREF="http://www.mysqlmanager.com/">www.mysqlmanager.com</A>) at 5/23/2008 3:59 PM</pre></TD>
      <TD ALIGN="left" WIDTH="54px" NOWRAP>
        <A HREF="personnelpayment.html"><IMG ALT="Previous topic" SRC="../Images/GoPrev.bmp" BORDER="0"></A>
        <A HREF="../Index.html"><IMG ALT="Chapter index" SRC="../Images/GoIndex.bmp" BORDER="0"></A>
        <A HREF="room.html"><IMG ALT="Next topic" SRC="../Images/GoNext.bmp" BORDER="0"></A>
      </TD>
    </TR>
  </TABLE>
<P CLASS="Base">&nbsp;</P></BODY>
</HTML>
